{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Expense & Mileage Claim Form"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Expense & Mileage Claim Form","index":0,"n_rows":60,"n_cols":6,"rows_kept":60,"cut":false,"hidden":false,"merged":[[1,0,1,5],[56,2,56,4],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[31,0,31,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[7,0,7,5],[23,0,23,5],[34,0,34,5],[15,1,15,2],[16,1,16,2],[17,1,17,2],[9,1,9,2],[10,1,10,2],[11,1,11,2],[51,1,51,4],[52,1,52,4],[50,0,50,5],[37,0,37,5],[18,1,18,2],[19,1,19,2],[20,1,20,2],[32,1,32,2]]}
[]
["Expense & Mileage Claim"]
["Name:"]
[]
["Vehicle Type","Petrol & Diesel",{"$f":"VLOOKUP(B5,A42:B44,2,FALSE)","v":34}]
[]
[]
["General Expense Claim"]
["Date dd/mm/yy","Particulars",null,"Amount (incl GST)","GST","GST EXCL"]
[null,"Taxi",null,32,{"$f":"D10/9","v":3.5555555555555554},{"$f":"D10-E10","v":28.444444444444443}]
[null,null,null,0,{"$f":"D11/9","v":0},0]
[null,null,null,0,0,0]
[null,null,null,0,0,0]
[null,null,null,0,0,0]
[null,null,null,0,0,0]
[null,null,null,0,0,0]
[null,null,null,0,0,0]
[null,null,null,0,0,0]
[null,null,null,0,0,0]
[null,null,null,0,0,0]
[null,null,null,0,0,0]
[null,"Total Expense Claim",null,{"$f":"SUM(D10:D21)","v":32},{"$f":"SUM(E10:E21)","v":3.5555555555555554},{"$f":"SUM(F10:F21)","v":28.444444444444443}]
[]
["Mileage Claim"]
["Date dd/mm/yy","Reason for Travel",null,"Starting Odometer","Ending Odometer","Distance Travelled"]
[null,"Travel to client meeting",null,10000,12500,{"$f":"IF(E26=\"\",,E26-D26)","v":2500}]
[null,null,null,null,null,{"$f":"IF(E27=\"\",,E27-D27)","v":0}]
[null,null,null,null,null,{"$f":"IF(E28=\"\",,E28-D28)","v":0}]
[null,null,null,null,"Total km",{"$f":"SUM(F26+F27+F28)","v":2500}]
[null,null,null,null,{"$f":"CONCATENATE(\"@ \",B39,\"c\",\" or \",C5,\"c\")","v":"@ 95c or 34c"},{"$f":"IF(F29>14000,((F29-14000)*IF($B$5=$A$42,B42/100,IF($B$5=A43,B43/100,IF($B$5=A44,B44/100,\"\"))))+(14000*$B$39/100),F29*$B$39/100)","v":2375}]
[null,null,null,null,"Total Mileage Claim",{"$f":"SUM(F30)","v":2375}]
["These rates are the Inland Revenue mileage rates",null,null,null,"95 cents per km "]
[null,"Choose your vehicle type at the top of the page to get the correct Tier 2 rate"]
[]
["Total Claim for Expenses & Mileage"]
[null,null,null,"Complete Claim Total",null,{"$f":"SUM(F31+D22)","v":2407}]
[]
["Mileage tier rates"]
["Tier 1 rate",95]
[]
["Tier 2 rate per kilometre depends on type of vehicle driven:"]
["Petrol & Diesel",34]
["Petrol hybrid",20]
["Electric",11]
[]
["Note:","The rates above are based on the rates provided by IRD at the time of preparation of the spreadsheet. Please check the latest rates on IRD website using link below. "]
[null,"To update the rates for calculations above, simply select the cell with appropriate rate, and type number of cents as per IRD website. Calculations will update automatically."]
[null,"https://www.ird.govt.nz/income-tax/income-tax-for-businesses-and-organisations/types-of-business-expenses/claiming-vehicle-expenses"]
[]
[]
["Tier rates explanation"]
["Tier 1  rates","The Tier 1 rate is a combination of your vehicle's fixed and running costs. Use it for the business portion of the first 14,000 kilometres travelled by the vehicle in a year. This includes private use travel."]
["Tier 2  rates","The Tier 2 rate is for running costs only. Use it for the business portion of any travel over 14,000 kilometres in a year. The Tier 2 rate depends on type of vehicle being used"]
[]
[]
[]
["Employee:"]
[]
[]
["Note:","Attach all invoices/receipts . (Note an EFTPOS receipt is not a valid tax invoice.)"]